package com.csun.dsms.model.huang;

import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.*;
import java.io.Serializable;
import java.util.Date;

/**
 * 7.项目建设清单
 * 红黑榜项目清单
 * 县市区 行业清单;
 */
@Data
@Table(name = "hg_project_data")
public class HgProjectData implements Serializable {

    private static final long serialVersionUID = -71227142114163L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;

    @Column(name = "statistical_year")
    private Integer statisticalYear;

    @Column(name = "statistical_month")
    private Integer statisticalMonth;

    @Column(name = "area")
    private String area;

    //1市 2 区县 3 行业 不分区县
    @Column(name = "area_level")
    private Integer areaLevel;

    private String industry;

    @Column(name = "total_num")
    private Integer totalNum;


    @Column(name = "red_num")
    private Integer redNum;

    @Column(name = "black_num")
    private Integer blackNum;
    /**
     * 项目责任部门
     */
    @Column(name = "entry_department")
    private String entryDepartment;

    @Column(name = "creator")
    private String creator;

    @Column(name = "approved")
    private Boolean approved;

    @Column(name = "approval")
    private String approval;

    @Column(name = "created_time")
    @DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "GMT+8")
    private Date createdTime;


}